Release 10.1A: OpenEdge Data Management:
SQL Reference

OpenEdge SQL keywords for 4GL table attributes

Table 52 lists the keywords to use when setting Progress 4GL table attributes with OpenEdge SQL statements.

Table 52: Table attribute details

Attribute keyword used in SQL statement	Description	Value
PRO_CAN_CREATE	Equivalent to 4GL CAN-CREATE.	Arbitrary character string.
PRO_CAN_DELETE	Equivalent to 4GL CAN-DELETE.	Arbitrary character string.
PRO_CAN_DUMP	Equivalent to 4GL CAN-DUMP.	Arbitrary character string.
PRO_CAN_LOAD	Equivalent to 4GL CAN-LOAD.	Arbitrary character string.
PRO_CAN_READ	Equivalent to 4GL CAN-READ.	Arbitrary character string.
PRO_CAN_WRITE	Equivalent to 4GL CAN-WRITE.	Arbitrary character string.
PRO_DESCRIPTION	Equivalent to 4GL DESCRIPTION.	Arbitrary character string.
PRO_DUMP_NAME	Equivalent to 4GL DUMP-NAME.	Arbitrary character string.
PRO_FROZEN	Equivalent to 4GL FROZEN. Note: OpenEdge SQL honors the value set here and does not allow modification of a frozen table using the ALTER TABLE, CREATE INDEX, CREATE PRO_WORD INDEX, DROP INDEX, or DROP TABLE commands. However, the frozen attribute may be set to ’N’ to unfreeze a frozen table. For example: ALTER TABLE Customer SET PRO_FROZEN ’N’;	’Y’|’y’|’N’|’n’
PRO_HIDDEN	Indicates whether the table is shown in 4GL tools and reports.	’Y’|’y’|’N’|’n’
PRO_LABEL	Equivalent to 4GL LABEL.	Arbitrary character string.
PRO_VALEXP	Indicates a 4GL validation expression.	Arbitrary character string.
PRO_VALMSG	Indicates a 4GL validation message.	Arbitrary character string.
PRO_SA_VALMS	Indicates a 4GL string attributes validation message.	Arbitrary character string.
PRO_SA_LABEL	Indicates a 4GL table label.	Arbitrary character string.
PRO_DEFAULT_INDEX	Determines default data-access index for a table.	Name of an index or table.

Table 53 lists the keywords to use when setting Progress 4GL column attributes with OpenEdge SQL statements.

Table 53: Column attribute details

Attribute keyword used in SQL statement	Description	Value
PRO_CAN_READ	Equivalent to 4GL CAN-READ.	Arbitrary character string.
PRO_CAN_WRITE	Equivalent to 4GL CAN-WRITE.	Arbitrary character string.
PRO_COL_LABEL	Equivalent to 4GL COL-LABEL.	Free-form text.
PRO_DESCRIPTION	Equivalent to 4GL DESCRIPTION.	Free-form text.
PRO_FORMAT	Equivalent to 4GL FORMAT.	4GL format string.
PRO_HELP	Indicates a 4GL help message.	Free-form text.
PRO_LABEL	Indicates 4GL label.	Free-form text.
PRO_RPOS	Indicates 4GL relative record position.	Positive integer.
PRO_SQL_WIDTH	Indicates SQL width.	Positive integer.
PRO_VIEW_AS	Equivalent to 4GL VIEW-AS.	Free-form text.
PRO_ORDER	Equivalent to 4GL ORDER.	Integer value.
PRO_VALEXP	Indicates 4GL validation expression.	Free-form text.
PRO_VALMSG	Indicates 4GL validation message.	Free-form text.
PRO_SA_LABEL	Indicates 4GL string attribute column label.	Arbitrary character string.
PRO_SA_COL_LABEL	Indicates 4GL string attribute column label.	Arbitrary character string.
PRO_SA_FORMAT	Indicates 4GL string attribute column label.	Arbitrary character string.
PRO_SA_INITIAL	Indicates 4GL string attribute column label.	Arbitrary character string.
PRO_SA_HELP	Indicates 4GL string attribute column label.	Arbitrary character string.
PRO_SA_VALMSG	Indicates 4GL string attribute column label.	Arbitrary character string.
DEFAULT Note: DEFAULT is a common attribute of both SQL and 4GL.	Indicates the default value for a column.	A literal value whose type is compatible with the type of the column.
PRO_CASE_SENSITIVE	Indicates case-sensitivity.	’Y’|’y’|’N’|’n’
PRO_LOB_SIZE_TEXT	The maximum size of a BLOB or CLOB column described as a string.	Free-form text. For example: ’32M’